package cn.oa.dao;

import cn.oa.entity.Attendance;

import java.sql.SQLException;
import java.util.List;

public interface AttendanceDao {
    //删除员工的所有考勤记录
    public int deleteAttendanceByEmployeeId(int employeeId) throws SQLException;
    //查找打卡记录
    public Attendance getRecordByEmployeeIdAndDate(int employeeId, String date) throws SQLException;
    //上班打卡
    public int addSinginByEmployeeId(int employeeId) throws SQLException;
    //根据考勤id记录签退
    public int updateSingoutByAttendanceId(int id) throws SQLException;
    //获取考勤记录
    public List<Attendance> getAttendancesByPage(String name, String searchDate, int pageNo, int pageSize) throws SQLException;

    //获取记录总数
    public int getAttendancesCount(String name, String searchDate) throws SQLException;
}
